﻿
-- 删除设备信息
create procedure [dbo].[SbInfo_Del]
@sblsh int
as
delete from DVR_Set where (select top 1 sblx from Sb_Info where sblsh=@sblsh)=3
delete from [Sb_Info] where sblsh=@sblsh